package com.feihao.zhou.otherMappers;

import com.feihao.zhou.bean.Course;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CourseMapper {
    //根据传入的cid 查询课程：
    @Select("SELECT c.id, c.name name FROM course c ,stu_cr sc WHERE c.id=sc.cid AND sc.sid = #{id}")
    List<Course> selectCourse();
}
